Field

Type

Size

Validation

Precision

Import Type

Transaction Type

Char

2

  AI, AO, DI, DO, GI, GO, WO

Standard / Extended

Stock Code

Char

30

Lookup

Standard / Extended

Transaction Date

Date

10

Date

Standard / Extended

Reference

Char

8

Standard / Extended

Details

Char

60

Standard / Extended

Quantity

Double

11

8 digits + 2 d.p.

Standard / Extended

Cost Price

Double

11

8 digits + 2 d.p.

Standard / Extended

Sales Price

Double

11

8 digits + 2 d.p.

Standard / Extended